let id = args.form[0].id;
let res =  lib.dbQueryJsonArray(`SELECT
		si.order_sn AS orderSn,
		sip.img AS productImg,
		sip.product_id AS productId,
		sip.sku AS sku,
		shop.shop_name AS shopId,
		listing.fnsku AS fnsku,
		si.warehouse AS warehouse,
		si.create_user AS createUser,
		si.create_time AS createTime,
		sip.good_product AS goodProduct,
		sip.defective_product AS defectiveProduct,
		sip.wait_quantity AS waitQuantity,
		si.status AS status
	FROM
		stock_in si
		LEFT JOIN receipt r ON si.associated_po = r.order_sn
		LEFT JOIN stock_in_product sip ON si.id = sip.parent_stock_in_id
	    LEFT JOIN shop_info shop on shop.id= sip.shop_id
		LEFT JOIN listing_father listing on listing.id=sip.fnsku
	WHERE
		r.id = ? 
		AND si.del_flag = 0;`,id)
res